FaDisbBatch

Logical Entity Name | FaDisbBatch
Default Table Name | FaDisbBatch
Physical Only | NO
Owner | dbo
Definition |
Note |

FaDisbBatch Columns

ColumnName | Domain | Datatype | NULL | Definition
FaDisbBatchID |  | int | NO |
SyCampusID |  | int | YES |
FaLenderID |  | int | YES |
NumDisb |  | int | YES |
BatchAmount |  | numeric(10, 2) | YES |
AmountApproved |  | numeric(10, 2) | NO |
OKToPost |  | bit | NO |
BatchOpen |  | bit | NO |
DatePosted |  | datetime | YES |
PostedByUserID |  | int | YES |
TransactionDate |  | datetime | YES |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
FaBatchExpImpID |  | int | YES |
ImportFileCode |  | char(1) | NO |
CLDetailRecords |  | int | YES |
CLNetDisbAmount |  | numeric(18, 0) | YES |
CLNetEFTAmount |  | numeric(18, 0) | YES |
CLNetNonEFTAmount |  | numeric(18, 0) | YES |
CLReissueAmount |  | numeric(18, 0) | YES |
CLCancelAmount |  | numeric(18, 0) | YES |
CLDeficitAmount |  | numeric(18, 0) | YES |
StudentsDropped |  | bit | NO |
InUseBySyStaffID |  | int | YES |
EditStartTime |  | datetime | YES |
RefundCriteriaChecked |  | bit | NO |
Reviewed |  | smallint | NO |
Extracted |  | bit | NO |
AmAgencyBranchID |  | int | YES |
ThirdPartyInvoiceNumber |  | varchar(50) | YES |
BatchLocked |  | bit | NO |
ParentFaDisbBatchID |  | int | YES |
DepositReceived |  | bit | NO |
DepositRequired |  | bit | NO |

FaDisbBatch Primary and Unique Keys

Key Name | Key Type | Keys
FaDisbBatch_FaDisbBatchID_U_C_IDX | PrimaryKey | FaDisbBatchID

FaDisbBatch Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
amAgencyBranch | Non-Identifying | Zero or One to Zero or More | FK_FaDisbBatch_AmAgencyBranchID_AmAgencyBranch_AmAgencyBranchID |  |  | AmAgencyBranchID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
FaDisbBatchDetail | Non-Identifying | One To Zero or More | FK_FaDisbBatchDetail_FaDisbBatchID_FaDisbBatch_FaDisbBatchID |  |  |  | NO | YES
FaDisbBatchDetailDisbInfo | Non-Identifying | One To Zero or More | FK_FaDisbBatchDetailDisbInfo_FaDisbBatchID_FaDisbBatch_FaDisbBatchID |  |  |  | NO | YES
SaReconcileDrawdownRequestDetail | Non-Identifying | One To Zero or More | FK_SaReconcileDrawdownRequestDetailFaDisbBatchId_FaDisbBatchFaDisbBatchId |  |  |  | NO | YES
SyAudit_FaDisbBatch | Non-Identifying | One To Zero or More | FK_SyAudit_FaDisbBatch_RecordID_FaDisbBatch_FaDisbBatchID |  |  |  | NO | YES

FaDisbBatch Check Constraints

Check Constraint Name | CheckConstraint

FaDisbBatch Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

FaDisbBatch Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.DisbursementBatch | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaDisbBatch | NO |  |  |

FaDisbBatch Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

FaDisbBatch Data Movement Rules

Name | Type | Rule Text/Value